﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using Titan.Oracle;

namespace Titan.Test.Entity
{
    [Table(TableName="(select a.customername,b.areaname,a.customertypeid from test_customer a left outer join test_area b on a.areaid=b.areaid)")]
    public class CustomerView
    {
        [Column()]
        public string CustomerName { get; set; }

        [Column()]
        public string AreaName { get; set; }
        [Column()]
        public int CustomerTypeId { get; set; }
    }


    [Statement(CommandText="test_sp")]
    public class SP
    {
        [Parameter]
        public int I1 { get; set; }
        [Parameter]
        public int I2 { get; set; }
        [Parameter(Direction = ParameterDirection.Output)]
        public int I3 { get; set; }
        [OracleCursor]
        public int Areas { get; set; }
        [OracleCursor]
        public int CompanyTypes { get; set; }
    }
}
